

/****** Object:  StoredProcedure [dbo].[SP_recMenuRights_Update]    Script Date: 05/10/2014 08:25:05 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Beni Khaeroni (jhung.ben@gmail.com)
-- Create date: 09 Mei 2014 10:20 AM
-- Description:	
-- =============================================
CREATE PROCEDURE [dbo].[SP_recMenuRights_Update]
(
	@MenuRightsID						[int],
	@MenuID						[int],
	@RoleID						[int],
	@AccessCode						[varchar](14)
	--@CreatedDate						[datetime],
	--@CreatedBy						[varchar](50)
)
AS UPDATE master.recMenuRights
SET
		--MenuRightsID			=	@MenuRightsID,
		MenuID			=	@MenuID,
		RoleID			=	@RoleID,
		AccessCode			=	@AccessCode
		--CreatedDate			=	@CreatedDate,
		--CreatedBy			=	@CreatedBy
WHERE
(
	 [MenuRightsID]	 = @MenuRightsID
)
GO


